Search results 60

  2. Search results
  3. . search
Card image cap
CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25
Card image cap
MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17
Card image cap
Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

2018Jun16
Card image cap
Match3

Matching three values at the same time in three columns Just like Match the ...

2018Jun16
Card image cap
HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

2018Jun16
Card image cap
MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...

2018Jun16
Card image cap
FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7
Card image cap
Filter_GotoItem

Allow users to select from list box based on search terms. Have a text box and ...

2018Jun7
Card image cap
FindIn1DArray

Returns 1 if an item found in array, 0 if not

2018Jun6
Card image cap
CutString3_Search

Using same code in CutString3, this will search for matching items. Searches ...

2018May29
Card image cap
CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23
Card image cap
IsThere1

Finds out if a file exists, can pass either mapped file path, or unmapped

2018Apr25